<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
	<head>
		<title></title>
		<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
		<meta name="ProgId" content="VisualStudio.HTML">
		<meta name="Originator" content="Microsoft Visual Studio .NET 7.1">
	</head>
	<body>
		<H1><A name="_information_schema.domains"></A>DOMAINS</H1>
		<P>Contains one row for each user-defined data type accessible to the current user 
			in the current database. The <B>INFORMATION_SCHEMA.DOMAINS</B> view is based on 
			the <B>spt_data type_info</B>, <B>systypes</B>, <B>syscomments</B>, <B>sysconfigures</B>, 
			and <B>syscharsets </B>system tables.</P>
		<P>To retrieve information from these views, specify the fully qualified name of <B>INFORMATION_SCHEMA</B><I>
				view_name</I>.</P>
		<TABLE id="Table1" cols="3" cellPadding="2" rules="all" width="587" border="1" frame="box">
			<TR vAlign="top">
				<TH class="label" width="36%">
					Column name</TH>
				<TH class="label" width="23%">
					Data type</TH>
				<TH class="label" width="41%">
					Description</TH></TR>
			<TR vAlign="top">
				<TD width="36%"><B>DOMAIN_CATALOG</B></TD>
				<TD width="23%"><B>nvarchar(128)</B></TD>
				<TD width="41%">Database in which the user-defined data type exists.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>DOMAIN_SCHEMA</B></TD>
				<TD width="23%"><B>nvarchar(128)</B></TD>
				<TD width="41%">User that created the user-defined data type.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>DOMAIN_NAME</B></TD>
				<TD width="23%"><B>sysname</B></TD>
				<TD width="41%">User-defined data type.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>DATA_TYPE</B></TD>
				<TD width="23%"><B>sysname</B></TD>
				<TD width="41%">System-supplied data type.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_MAXIMUM_LENGTH</B>
				</TD>
				<TD width="23%"><B>smallint</B></TD>
				<TD width="41%">Maximum length, in characters, for binary data, character data, or 
					text and image data. Otherwise, NULL is returned. For more information, see <A href="ts_da-db_7msw.asp">
						Data Types</A>.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_OCTET_LENGTH</B></TD>
				<TD width="23%"><B>smallint</B></TD>
				<TD width="41%">Maximum length, in bytes, for binary data, character data, or text 
					and image data. Otherwise, NULL is returned.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>COLLATION_CATALOG</B></TD>
				<TD width="23%"><B>varchar(6)</B></TD>
				<TD width="41%">Returns <B>master</B>, indicating the database in which the sort 
					order is defined, if the column is character data or <B>text</B> data type. 
					Otherwise, this column is NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>COLLATION_SCHEMA</B></TD>
				<TD width="23%"><B>varchar(3)</B></TD>
				<TD width="41%">Returns DBO, indicating the owner of the sort order for character 
					data or <B>text</B> data type. Otherwise, NULL is returned.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>COLLATION_NAME</B></TD>
				<TD width="23%"><B>nvarchar(128)</B></TD>
				<TD width="41%">Returns the unique name for the sort order if the column is 
					character data or <B>text</B> data type. Otherwise, NULL is returned.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_SET_CATALOG</B></TD>
				<TD width="23%"><B>varchar(6)</B></TD>
				<TD width="41%">Returns <B>master</B>, indicating the database in which the 
					character set is located, if the column is character data or <B>text</B> data 
					type. Otherwise, NULL is returned.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_SET_SCHEMA</B>
				</TD>
				<TD width="23%"><B>varchar(3)</B></TD>
				<TD width="41%">Returns DBO, indicating the owner name of the character set, if the 
					column is <B>character</B> data or <B>text</B> data type. Otherwise, NULL is 
					returned.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_SET_NAME</B></TD>
				<TD width="23%"><B>nvarchar(128)</B></TD>
				<TD width="41%">Returns the unique name for the character set if this column is 
					character data or <B>text</B> data type. Otherwise, NULL is returned.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>NUMERIC_PRECISION</B></TD>
				<TD width="23%"><B>tinyint</B></TD>
				<TD width="41%">Precision of approximate numeric data, exact numeric data, integer 
					data, or monetary data. Otherwise, NULL is returned.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>NUMERIC_PRECISION_RADIX</B></TD>
				<TD width="23%"><B>smallint</B></TD>
				<TD width="41%">Precision radix of approximate numeric data, exact numeric data, 
					integer data, or monetary data. Otherwise, NULL is returned.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>NUMERIC_SCALE</B></TD>
				<TD width="23%"><B>tinyint</B></TD>
				<TD width="41%">Scale of approximate numeric data, exact numeric data, integer 
					data, or monetary data. Otherwise, NULL is returned.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>DATETIME_PRECISION</B></TD>
				<TD width="23%"><B>smallint</B></TD>
				<TD width="41%">Subtype code for <B>datetime</B> and SQL-92<B> interval </B>data 
					type. For other data types, this column returns a NULL.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>DOMAIN_DEFAULT</B></TD>
				<TD width="23%"><B>nvarchar(4000)</B></TD>
				<TD width="41%">Actual text of the definition Transact-SQL statement.</TD>
			</TR>
		</TABLE>
	</body>
</html>
